Pandas Profiling Report

Dataset statistics

Number of variables	10
Number of observations	768
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	60.1 KiB
Average record size in memory	80.2 B

Variable types

NUM	9
BOOL	1

Warnings

`df_index` has unique values	Unique
`Pregnant` has 111 (14.5%) zeros	Zeros
`Insulin` has 138 (18.0%) zeros	Zeros

Reproduction

Analysis started	2020-11-06 11:41:09.103455
Analysis finished	2020-11-06 11:41:28.105702
Duration	19 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	768
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	383.5
Minimum	0
Maximum	767
Zeros	1
Zeros (%)	0.1%
Memory size	6.0 KiB

Quantile statistics

Minimum	0
5-th percentile	38.35
Q1	191.75
median	383.5
Q3	575.25
95-th percentile	728.65
Maximum	767
Range	767
Interquartile range (IQR)	383.5

Descriptive statistics

Standard deviation	221.846794
Coefficient of variation (CV)	0.5784792542
Kurtosis	-1.2
Mean	383.5
Median Absolute Deviation (MAD)	192
Skewness	0
Sum	294528
Variance	49216
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
767	1	0.1%
766	1	0.1%
261	1	0.1%
260	1	0.1%
259	1	0.1%
258	1	0.1%
257	1	0.1%
256	1	0.1%
255	1	0.1%
254	1	0.1%
Other values (758)	758	98.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	0.1%
1	1	0.1%
2	1	0.1%
3	1	0.1%
4	1	0.1%

Value	Count	Frequency (%)
767	1	0.1%
766	1	0.1%
765	1	0.1%
764	1	0.1%
763	1	0.1%

Pregnant
Real number (ℝ_≥0)

ZEROS

Distinct	17
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.845052083
Minimum	0
Maximum	17
Zeros	111
Zeros (%)	14.5%
Memory size	6.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	6
95-th percentile	10
Maximum	17
Range	17
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	3.369578063
Coefficient of variation (CV)	0.8763413316
Kurtosis	0.1592197775
Mean	3.845052083
Median Absolute Deviation (MAD)	2
Skewness	0.9016739792
Sum	2953
Variance	11.35405632
Monotocity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
1	135	17.6%
0	111	14.5%
2	103	13.4%
3	75	9.8%
4	68	8.9%
5	57	7.4%
6	50	6.5%
7	45	5.9%
8	38	4.9%
9	28	3.6%
Other values (7)	58	7.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	111	14.5%
1	135	17.6%
2	103	13.4%
3	75	9.8%
4	68	8.9%

Value	Count	Frequency (%)
17	1	0.1%
15	1	0.1%
14	2	0.3%
13	10	1.3%
12	9	1.2%

Glucose
Real number (ℝ_≥0)

Distinct	135
Distinct (%)	17.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	121.6770833
Minimum	44
Maximum	199
Zeros	0
Zeros (%)	0.0%
Memory size	6.0 KiB

Quantile statistics

Minimum	44
5-th percentile	80
Q1	99.75
median	117
Q3	140.25
95-th percentile	181
Maximum	199
Range	155
Interquartile range (IQR)	40.5

Descriptive statistics

Standard deviation	30.46416059
Coefficient of variation (CV)	0.2503689253
Kurtosis	-0.2681052005
Mean	121.6770833
Median Absolute Deviation (MAD)	20
Skewness	0.532324244
Sum	93448
Variance	928.0650804
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
99	17	2.2%
100	17	2.2%
129	14	1.8%
106	14	1.8%
107	14	1.8%
111	14	1.8%
125	14	1.8%
105	13	1.7%
108	13	1.7%
112	13	1.7%
Other values (125)	625	81.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
44	1	0.1%
56	1	0.1%
57	2	0.3%
61	1	0.1%
62	1	0.1%

Value	Count	Frequency (%)
199	1	0.1%
198	1	0.1%
197	4	0.5%
196	3	0.4%
195	2	0.3%

BloodPressure
Real number (ℝ_≥0)

Distinct	46
Distinct (%)	6.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	72.37890625
Minimum	24
Maximum	122
Zeros	0
Zeros (%)	0.0%
Memory size	6.0 KiB

Quantile statistics

Minimum	24
5-th percentile	52
Q1	64
median	72
Q3	80
95-th percentile	90
Maximum	122
Range	98
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	12.10443141
Coefficient of variation (CV)	0.1672370037
Kurtosis	1.088083343
Mean	72.37890625
Median Absolute Deviation (MAD)	8
Skewness	0.1434132121
Sum	55587
Variance	146.5172598
Monotocity	Not monotonic

Histogram with fixed size bins (bins=46)

Value	Count	Frequency (%)
70	76	9.9%
74	68	8.9%
68	45	5.9%
78	45	5.9%
72	44	5.7%
64	43	5.6%
80	40	5.2%
76	39	5.1%
60	37	4.8%
62	34	4.4%
Other values (36)	297	38.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
24	1	0.1%
30	2	0.3%
38	1	0.1%
40	1	0.1%
44	4	0.5%

Value	Count	Frequency (%)
122	1	0.1%
114	1	0.1%
110	3	0.4%
108	2	0.3%
106	3	0.4%

SkinThickness
Real number (ℝ_≥0)

Distinct	50
Distinct (%)	6.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	27.43098958
Minimum	7
Maximum	99
Zeros	0
Zeros (%)	0.0%
Memory size	6.0 KiB

Quantile statistics

Minimum	7
5-th percentile	14.35
Q1	21
median	27
Q3	32
95-th percentile	44
Maximum	99
Range	92
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	9.321460459
Coefficient of variation (CV)	0.3398149539
Kurtosis	4.392371469
Mean	27.43098958
Median Absolute Deviation (MAD)	6
Skewness	1.128742746
Sum	21067
Variance	86.8896251
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
21	149	19.4%
27	111	14.5%
32	31	4.0%
30	27	3.5%
23	22	2.9%
28	20	2.6%
33	20	2.6%
18	20	2.6%
31	19	2.5%
19	18	2.3%
Other values (40)	331	43.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
7	2	0.3%
8	2	0.3%
10	5	0.7%
11	6	0.8%
12	7	0.9%

Value	Count	Frequency (%)
99	1	0.1%
63	1	0.1%
60	1	0.1%
56	1	0.1%
54	2	0.3%

Insulin
Real number (ℝ_≥0)

ZEROS

Distinct	187
Distinct (%)	24.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	91.78385417
Minimum	0
Maximum	846
Zeros	138
Zeros (%)	18.0%
Memory size	6.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	39
median	39
Q3	127.25
95-th percentile	293
Maximum	846
Range	846
Interquartile range (IQR)	88.25

Descriptive statistics

Standard deviation	108.1211361
Coefficient of variation (CV)	1.177997341
Kurtosis	8.901933955
Mean	91.78385417
Median Absolute Deviation (MAD)	39
Skewness	2.524252679
Sum	70490
Variance	11690.18008
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
39	236	30.7%
0	138	18.0%
105	11	1.4%
140	9	1.2%
130	9	1.2%
120	8	1.0%
94	7	0.9%
100	7	0.9%
180	7	0.9%
115	6	0.8%
Other values (177)	330	43.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	138	18.0%
14	1	0.1%
15	1	0.1%
16	1	0.1%
18	2	0.3%

Value	Count	Frequency (%)
846	1	0.1%
744	1	0.1%
680	1	0.1%
600	1	0.1%
579	1	0.1%

BMI
Real number (ℝ_≥0)

Distinct	249
Distinct (%)	32.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	32.43391927
Minimum	18.2
Maximum	67.1
Zeros	0
Zeros (%)	0.0%
Memory size	6.0 KiB

Quantile statistics

Minimum	18.2
5-th percentile	22.235
Q1	27.5
median	32.05
Q3	36.6
95-th percentile	44.395
Maximum	67.1
Range	48.9
Interquartile range (IQR)	9.1

Descriptive statistics

Standard deviation	6.880664091
Coefficient of variation (CV)	0.2121440839
Kurtosis	0.9153719011
Mean	32.43391927
Median Absolute Deviation (MAD)	4.55
Skewness	0.6066504576
Sum	24909.25
Variance	47.34353834
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
32	13	1.7%
31.2	12	1.6%
31.6	12	1.6%
32.4	10	1.3%
33.3	10	1.3%
32.8	9	1.2%
30.1	9	1.2%
30.05	9	1.2%
32.9	9	1.2%
30.8	9	1.2%
Other values (239)	666	86.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
18.2	3	0.4%
18.4	1	0.1%
19.1	1	0.1%
19.3	1	0.1%
19.4	1	0.1%

Value	Count	Frequency (%)
67.1	1	0.1%
59.4	1	0.1%
57.3	1	0.1%
55	1	0.1%
53.2	1	0.1%

DiabetesPedigree
Real number (ℝ_≥0)

Distinct	517
Distinct (%)	67.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.4718763021
Minimum	0.078
Maximum	2.42
Zeros	0
Zeros (%)	0.0%
Memory size	6.0 KiB

Quantile statistics

Minimum	0.078
5-th percentile	0.14035
Q1	0.24375
median	0.3725
Q3	0.62625
95-th percentile	1.13285
Maximum	2.42
Range	2.342
Interquartile range (IQR)	0.3825

Descriptive statistics

Standard deviation	0.331328595
Coefficient of variation (CV)	0.7021513764
Kurtosis	5.594953528
Mean	0.4718763021
Median Absolute Deviation (MAD)	0.1675
Skewness	1.919911066
Sum	362.401
Variance	0.1097786379
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.254	6	0.8%
0.258	6	0.8%
0.259	5	0.7%
0.207	5	0.7%
0.261	5	0.7%
0.268	5	0.7%
0.238	5	0.7%
0.284	4	0.5%
0.687	4	0.5%
0.27	4	0.5%
Other values (507)	719	93.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.078	1	0.1%
0.084	1	0.1%
0.085	2	0.3%
0.088	2	0.3%
0.089	1	0.1%

Value	Count	Frequency (%)
2.42	1	0.1%
2.329	1	0.1%
2.288	1	0.1%
2.137	1	0.1%
1.893	1	0.1%

Age
Real number (ℝ_≥0)

Distinct	52
Distinct (%)	6.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	33.24088542
Minimum	21
Maximum	81
Zeros	0
Zeros (%)	0.0%
Memory size	6.0 KiB

Quantile statistics

Minimum	21
5-th percentile	21
Q1	24
median	29
Q3	41
95-th percentile	58
Maximum	81
Range	60
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	11.76023154
Coefficient of variation (CV)	0.3537881556
Kurtosis	0.6431588885
Mean	33.24088542
Median Absolute Deviation (MAD)	7
Skewness	1.129596701
Sum	25529
Variance	138.3030459
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
22	72	9.4%
21	63	8.2%
25	48	6.2%
24	46	6.0%
23	38	4.9%
28	35	4.6%
26	33	4.3%
27	32	4.2%
29	29	3.8%
31	24	3.1%
Other values (42)	348	45.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
21	63	8.2%
22	72	9.4%
23	38	4.9%
24	46	6.0%
25	48	6.2%

Value	Count	Frequency (%)
81	1	0.1%
72	1	0.1%
70	1	0.1%
69	2	0.3%
68	1	0.1%

Outcome
Boolean

Distinct	2
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	6.0 KiB

0	500
1	268

Common Values
Chart

Value	Count	Frequency (%)
0	500	65.1%
1	268	34.9%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

First rows

	df_index	Pregnant	Glucose	BloodPressure	SkinThickness	Insulin	BMI	DiabetesPedigree	Age	Outcome
0	0	4.0	117.0	62.0	12.0	0.0	29.7	0.380	30.0	1
1	1	4.0	158.0	78.0	27.0	0.0	32.9	0.803	31.0	1
2	2	2.0	118.0	80.0	27.0	0.0	42.9	0.693	21.0	1
3	3	13.0	129.0	74.0	30.0	0.0	39.9	0.569	44.0	1
4	4	5.0	162.0	104.0	27.0	0.0	37.7	0.151	52.0	1
5	5	7.0	114.0	64.0	27.0	0.0	27.4	0.732	34.0	1
6	6	6.0	102.0	82.0	27.0	0.0	30.8	0.180	36.0	1
7	7	1.0	196.0	76.0	36.0	249.0	36.5	0.875	29.0	1
8	8	9.0	102.0	76.0	37.0	0.0	32.9	0.665	46.0	1
9	9	7.0	161.0	86.0	27.0	0.0	30.4	0.165	47.0	1

Last rows

	df_index	Pregnant	Glucose	BloodPressure	SkinThickness	Insulin	BMI	DiabetesPedigree	Age
758	758	5.0	132.0	80.0	21.0	39.0	26.8	0.186	69.0
759	759	9.0	91.0	68.0	21.0	39.0	24.2	0.200	58.0
760	760	3.0	128.0	78.0	21.0	39.0	21.1	0.268	55.0
761	761	0.0	108.0	68.0	20.0	39.0	27.3	0.787	32.0
762	762	2.0	112.0	68.0	22.0	94.0	34.1	0.315	26.0
763	763	1.0	81.0	74.0	41.0	57.0	46.3	1.096	32.0
764	764	4.0	94.0	65.0	22.0	39.0	24.7	0.148	21.0
765	765	3.0	158.0	64.0	13.0	387.0	31.2	0.295	24.0
766	766	0.0	57.0	60.0	21.0	39.0	21.7	0.735	67.0
767	767	4.0	95.0	60.0	32.0	39.0	35.4	0.284	28.0

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows